Computer Science Lesson Plan
Class: 6th to 8th, Lesson 2.3 : Editing operations in spreadsheet

Purpose: Students should learn Cut, Copy, Paste, Delete Row/ Delete column, Resize column and row, Delete sheet in Spreadsheet.

No. of Classes

Depending upon the class strength and number of computers (Two classes for 20 students.)

Material Required

Open office(Spreadsheet).

Curriculum Content
  • 3.3.7) Editing operations
  • Cut
  • Copy
  • Paste
  • Delete Row/ Delete column
  • Resize column and row
  • Delete sheet

    • Prior knowledge

    Students should complete lesson plan-2.2 clearly.

    Exercises

    Exercise:1


    1. Students should copy an image and paste it in a new spreadsheet file and save the spreadsheet file.

    Exercise:2


    2. Delete sheet -2 in the spreadsheet and rename the sheet-3.

    Solution



    Teacher's Instruction
    1. Teachers should instruct the Students to open a new spreadsheet and complete the above two exercises.
    2. Teachers should ensure that Students learn how to save a Spreadsheet file.
    3. Teachers should explain to the Students about the differences between ‘cut’ and ‘copy’.